Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RewardDerivationRuleEligibilityID (FK) | A unique identifier for a Price Derivation Rule Eligibility. | ID_EL_PRDV | Identity | integer | ZPromotionalOfferRewardDerivationRule(RU_PRM_PRDV) |
PriceModificationTypeCode (PK) | The type code used as a look up key for the standard price modification types represented in the Price Modification. | TY_MDF | Code2 | char(2) | |
FinancialLedgerAccountID (FK) | The reference for the FinancialLedgeraAccount | ID_ACNT_LDG | Identity | integer | FinancialLedgerAccount(CO_LE_ACNT_FN) |
PriceModificationTypeName | The name of the standard price modification types represented in the Price Modification. | NM_MDF | Name | varchar(40) | |
Description | A text description of the standard price modification types represented in the Price Modification entity collection. | DE_MDF | DescriptionShort | varchar(255) | |
PriceModificationMethodCode | A code denoting the method of modifying the price that is being applied to the transaction. Possible values include, Monetary Amount, Percentage, New Price Amount and Cost Plus Price. | CD_RDN_MTH | Code2 | char(2) | |
ModifyByPercent | The percent adjustment that was applied to the unit retail price to arrive at the modified selling price. Example Base price $10.00 ModifyByPercent 5% (.05) Price Modification to be applied is $.50 | PE_MDFR_RT_PRC | Percent | decimal(7,4) | |
ModifyByAmount | A flat monetary value that is to be added to or subtracted from a base price. (Note typically this is a discount so subtraction is the expected action) Example: Base price $10.00 ModifyByAmountt $.50 Price Modification to be applied is $.50 | MO_MDFR_RT_PRC | Money | decimal(16,5) | |
NewPriceAmount | The amount expressed as the new price for the item. | MO_NW_PRC | Money | decimal(16,5) | |
AdjustmentMethodCode | A symbol code denoting what kind of adjustment is being made to the retail price of the Item. e.g. Increase, Decrease. '+' = Add to base retail (amount before price modifier '-' = Subtract from base retail '=' = Replace base retail with ModifyByAmount | CD_MTH_ADJT | Code2 | char(2) | |
ProRatedFlag | A flag instructing POS to pro-rate the price modification across two or more SaleReturnLineItems and to record the application of this as RetailPriceModifier rather than PriceModificationLineItem. | FL_PRRT | Flag | integer | |
EffectiveDateTime | The date & time after which the Price Modification is applicable. | TS_EF | EffectiveDateTime | datetime | |
ExpirationDateTime | The date & time after which the Price Modification is no longer applicable. | TS_EP | ExpirationDateTime | datetime | |